Exercise 10.4

The solution uses the UNIQUE keyword, for example,

CREATE TABLE policyholder (
 ...
 accountNumber INT UNIQUE NOT NULL, 
 ...
    

To view the code for the updated ResetDB procedure, use the Database Explorer, and expand the Stored Procedures node of the Database.mdf file.  You can then view the procedure, or execute it, by right clicking the mouse over the stored procedure's name.